Release 10.1A: OpenEdge Data Management:
Database Administration

Collation Table (-cpcoll)

Operating system and syntax	UNIX Windows	-cpcoll tablename
Use with	Maximum value	Minimum value	Single-user default	Multi-user default
CS, DBS	–	–	Basic	Basic

tablename

The name of a collation table within the convmap.cp file.

Use Collation Table (-cpcoll) to identify a collation table to be used with the code page in memory. The code page is specified by the Internal Code Page (-cpinternal) parameter.

The collation rules that you specify are used to compare characters and sort records if a BY clause cannot be satisfied by an index. The collation rules specified with the -cpcoll parameter take precedence over the collation specified for any database accessed during the session, except when pre-existing indexes are used or modified. When you update or rebuild a database’s indexes, the collation rules originally defined for that database are used.

If you do not use -cpcoll, the language collation rules defined for the first database on the command line are used. If you do not specify a database on the command line, collation rules with the name “basic” are used.

To retrieve the value of this startup parameter at run time, use the SESSION System handle.

See OpenEdge Development: Internationalizing Applications for more information on collation tables.